package com.zkthink.ceres.applet.server.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zkthink.ceres.applet.product.domain.vo.MyServerOrProductVo;
import com.zkthink.ceres.applet.server.domain.entity.AppletVehiclesServer;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**

@Author cmz
@Date 2024-04-30 13:17
*/
public interface AppletVehiclesServerMapper extends BaseMapper<AppletVehiclesServer> {
    @Select("SELECT ass.id, ase.title `serverName`, ase.img, ass.group_buy_price price FROM applet_vehicles_server ass LEFT JOIN applet_server ase ON ass.server_id = ase.id where ass.is_delete !=1 and  ass.vehicles_id = #{id} ")
    List<MyServerOrProductVo> selectByVehiclesId(Long id);
}